UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6iKIL+FEfIxTFuBM4NnDbFE0TFPD6Hyh9YBeUYefZaY='
WHERE
key_id = 'e864124e5825258bc53efba3108d4aa7ebdaf91676eb8e1171d45f47f088fc1f'
AND (
token = '6iKIL+FEfIxTFuBM4NnDbFE0TFPD6Hyh9YBeUYefZaY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)