UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VzI/dCOOLZzouJHYzBXUdeiSZAYFPL+NHv65QT+fGUw='
WHERE
key_id = 'dc4798fc1975e3e4d67f9a5f7b2e3905df1d607f4edabc20a850ba80eb0aa9ab'
AND (
token = 'VzI/dCOOLZzouJHYzBXUdeiSZAYFPL+NHv65QT+fGUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)