UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9gEQwssogXUcOPwHp9dcLYUUGZiX6dfx3G4ZFP1++M4='
WHERE
key_id = 'd0998302ff1e51a93c3ca62d2ec58e82e8f79e6e8a7ad0d0b9715bc23af4180f'
AND (
token = '9gEQwssogXUcOPwHp9dcLYUUGZiX6dfx3G4ZFP1++M4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)