UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QwqtUWoKgoBJ6CU3fw5OUIrd+a8NJO9562ip3kU2Jz0=' 
WHERE 
  key_id = '66e70f37a8b70353e77b6b8adeebd99aa5fa8d8c9bcd5c723dd9083f56fee156' 
  AND (
    token = 'QwqtUWoKgoBJ6CU3fw5OUIrd+a8NJO9562ip3kU2Jz0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034