UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KEKiLlZONs02ONhKRv9ynt0NUX7tvzxgxRHQ9/YgQWs='
WHERE
key_id = 'dafeceffc6e1809845903a622ef76d165297d07037484aaa4b84e96ea8651dae'
AND (
token = 'KEKiLlZONs02ONhKRv9ynt0NUX7tvzxgxRHQ9/YgQWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)