UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6qZhImEttnz2gdEuYwUYmzXA5J/QW4VcLO9Ur0kXsns=' 
WHERE 
  key_id = '00852a5d6d03e94c8bfb4a976cd4d11dc54e96fba932cc75657a68fb35ce163c' 
  AND (
    token = '6qZhImEttnz2gdEuYwUYmzXA5J/QW4VcLO9Ur0kXsns=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033