UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sxPM82tT+MkbVqLfyHrzEQBljrjbGQM6GnR8R1/CuOU='
WHERE
key_id = 'ca27468b322d09ad5b1a1d49d05e9837e78e05a4ff51326828170e27f3953189'
AND (
token = 'sxPM82tT+MkbVqLfyHrzEQBljrjbGQM6GnR8R1/CuOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)