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