UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XAQhoD+zRR3P4+f9dfC+nwRfcMmYZEzZKypZQX+vLvs='
WHERE
key_id = '7597c77849c9e7d20ad9bea8000d247043395e4d525a4e9d78007dba77355c07'
AND (
token = 'XAQhoD+zRR3P4+f9dfC+nwRfcMmYZEzZKypZQX+vLvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)