UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yIfY/Vd0EJsTWd79tNLM1qvEs3R0vneaKnNJcC/2Mpg='
WHERE
key_id = '47b6bd2a83f809023d09b17eeef61507dc70bbe60659afb2948ddf658a107222'
AND (
token = 'yIfY/Vd0EJsTWd79tNLM1qvEs3R0vneaKnNJcC/2Mpg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)