UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ckYZLJPPh4APlxDkDKURcfciZH4TxLleS5PI6aqGjzE='
WHERE
key_id = '48bd518702e4dae3601746e61484603e85ea91daf9974a4d04be97311944ad76'
AND (
token = 'ckYZLJPPh4APlxDkDKURcfciZH4TxLleS5PI6aqGjzE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)