UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ux8OPhgM8mJVVG+yWlOk6vY0nzutrZD6BsQXFQCZ8Uo='
WHERE
key_id = 'd2721f7f920c0af644d421c9f0db96b9587283fb58664b0b6b3b946c94b5f8b4'
AND (
token = 'ux8OPhgM8mJVVG+yWlOk6vY0nzutrZD6BsQXFQCZ8Uo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)