UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Pf4zkAJ6ISs3D+h9Dj7z5IlzOi+ctk1X/BquDbr8B0='
WHERE
key_id = '7ea20bf3806df858ede663c076f2c1243f9b208ce2d617037e4601e893adf1e7'
AND (
token = '6Pf4zkAJ6ISs3D+h9Dj7z5IlzOi+ctk1X/BquDbr8B0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)