UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B2N2i1lPlOPAwd2AS6zZmoAk7KOM2XdLPsa75tofPLM='
WHERE
key_id = '8c520d2c01ba4217a11723c09a4298b299945e084612af56e7aa7883a6e46ed1'
AND (
token = 'B2N2i1lPlOPAwd2AS6zZmoAk7KOM2XdLPsa75tofPLM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)