UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MEsOn2Wqv+M47YDgqq8qW2BsCld0XFOzHioE587Rnls='
WHERE
key_id = 'b0b84975d35eca685f4e76fa031e731fab08a5121dcfecbecb38248352ef74ff'
AND (
token = 'MEsOn2Wqv+M47YDgqq8qW2BsCld0XFOzHioE587Rnls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)