UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9JfuOz9fNpFKIDJmz1YorwoHxL+hFp3Y7sR5gei1ws4='
WHERE
key_id = 'af5223d89037bbfbec0bca83dd1d852eeb2604a908052be50c666588a3eafc08'
AND (
token = '9JfuOz9fNpFKIDJmz1YorwoHxL+hFp3Y7sR5gei1ws4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)