UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J/vTx4+ixWDMsZKezimg2ZhpGf2JC8LICWN5f13zVuM='
WHERE
key_id = '364e92cab7359623f7f256d92bb30926b36fc40e6f4f7fe98cdb5848d7e80f04'
AND (
token = 'J/vTx4+ixWDMsZKezimg2ZhpGf2JC8LICWN5f13zVuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)