UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0BP147akFfmbo+3rSLbXm/+Os3BcKWAS1CkMy2ryh98='
WHERE
key_id = 'b868834d9432ffe453cf4dfddbbf7a996a289302fed888553a93df8dfe745506'
AND (
token = '0BP147akFfmbo+3rSLbXm/+Os3BcKWAS1CkMy2ryh98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)