UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N+USdBQS6M0k7RL196sACqAxdpBkfmzuQiXZM8n/2NI='
WHERE
key_id = 'cefb6270292c87505c8e9daa0edf8a75aae773115406ed94e7425d43e0d185f6'
AND (
token = 'N+USdBQS6M0k7RL196sACqAxdpBkfmzuQiXZM8n/2NI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)