UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rdWfKCFEiC1tMnN14Adp9+T/pPiZpLjpYecydk4dnc4='
WHERE
key_id = 'c507725f71e4f7847215a8b1cbc31ed01973b68bd8a451b62e483d803270361b'
AND (
token = 'rdWfKCFEiC1tMnN14Adp9+T/pPiZpLjpYecydk4dnc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)