UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bAaolPInisYJXfKHU7xzOkVAVyuYNU6RbOIJw/t6EEc='
WHERE
key_id = 'cf8f91d908e6dc23e0a27b471e8b82fb06c85382f98dd4ccaa953ee56991e65a'
AND (
token = 'bAaolPInisYJXfKHU7xzOkVAVyuYNU6RbOIJw/t6EEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)