UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CgQO3gkXbl6VhVjfgviJN4h7GKdAWsdYBW/KNXkinUw='
WHERE
key_id = 'bfe9088a81863bbea5fe36a6186938bf06dd78f9450ed17154fbc14e16c80999'
AND (
token = 'CgQO3gkXbl6VhVjfgviJN4h7GKdAWsdYBW/KNXkinUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)