UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TnMXKVlMzPZ+gQS4A36msEo1meL+FFB3+LrEDLvZ3KU='
WHERE
key_id = '720705c19270836865d39143e980dcc7afcafa2c7da6c14d9b8f5608a727f3e2'
AND (
token = 'TnMXKVlMzPZ+gQS4A36msEo1meL+FFB3+LrEDLvZ3KU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)