UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NYeHpYtN8PIf1jD9hvfclB+CsEa8ToN9qesPwxMsvLw='
WHERE
key_id = '742a57d580092de3b190df0288a6fe3116eee6918792f702db01e2b6557bdab6'
AND (
token = 'NYeHpYtN8PIf1jD9hvfclB+CsEa8ToN9qesPwxMsvLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)