UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'txTjO+Fp5Ii04KAILNFfvS/sYsgTPQVgCLITgzFrbHM='
WHERE
key_id = 'a6d5f281165ee39b52a0ca4376ed2d926c364f82c8f88f25542774fe70872414'
AND (
token = 'txTjO+Fp5Ii04KAILNFfvS/sYsgTPQVgCLITgzFrbHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)