UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qfw7MbaglNW1ZU9YTSD5yopX0Wfoik4c1PLtJxOEjMY='
WHERE
key_id = '42b82ba4d98250968cc2bbf2be69ba7827c35b8a095ab1d07f0a5f15563aa12a'
AND (
token = 'qfw7MbaglNW1ZU9YTSD5yopX0Wfoik4c1PLtJxOEjMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)