UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6QKLDkwtxZTCEavEP1BXQZL/uMcptaSZln+Lv3z/TG0='
WHERE
key_id = '06e8f7134244341c6ee1a0ed47e9ef67ab14ce3e98114f6e8a45616ed2e50093'
AND (
token = '6QKLDkwtxZTCEavEP1BXQZL/uMcptaSZln+Lv3z/TG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)