SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '31ce41bae92ad72496254c1c6f750dd87ecd2377ff9f0dfa0ce40f2910f22b83' 
  AND token = 'we/KQFfpDOoI3xirLea2FAw7MkLrj7a0cIKqFTRkI84=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00044

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}