UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hSSz1l3foU4rgcWF6btVIYQh0Z1AaMKCKIukj0ZWcRY='
WHERE
key_id = '5c54e8a361189337401f8354314ca6fd760a32e04d608bc42feba44dc22e03d0'
AND (
token = 'hSSz1l3foU4rgcWF6btVIYQh0Z1AaMKCKIukj0ZWcRY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)