UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T9vkJw6iNXrGj70JgQM5zPkF22U0D8XD4bMAf192JsU='
WHERE
key_id = 'f8d1106dc40f9345ba3acb2b78db58edd31265cb63223cb367aa94b5b41929a5'
AND (
token = 'T9vkJw6iNXrGj70JgQM5zPkF22U0D8XD4bMAf192JsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)