UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VpC2n4RttoLzBuabHcF0vDJMXhFVPfTogw6RNswUZhc='
WHERE
key_id = '4e1f595d7900cfc47a8b585d17de528a1439de4f4c499620b401df799a1ea0dd'
AND (
token = 'VpC2n4RttoLzBuabHcF0vDJMXhFVPfTogw6RNswUZhc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)