UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QySgwC+9BdD7RA85iFM+jlVYR7GUmAnE+e44rzMb0sE='
WHERE
key_id = '4f580d95b1de07be266daece0896a693b5e8000f67a2489bf4df6192f5bcd14b'
AND (
token = 'QySgwC+9BdD7RA85iFM+jlVYR7GUmAnE+e44rzMb0sE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)