UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e+Z7l7P4CHcZLDxrG/bAuufiEaP0eazRgmrENprFWZw='
WHERE
key_id = 'bb78e9d88ca343d6e8fac0a8a35a357ff4b8183c281763031ebcfffcfd95b81f'
AND (
token = 'e+Z7l7P4CHcZLDxrG/bAuufiEaP0eazRgmrENprFWZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)