UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xANAuOcCGdmnvFXC6+ti9cDeToeudpBJKnmOIAwzkR0='
WHERE
key_id = 'fd846c064fd5af130c4539860123ceb776f31f0aa0fb557d24a4b2466a425a91'
AND (
token = 'xANAuOcCGdmnvFXC6+ti9cDeToeudpBJKnmOIAwzkR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)