SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '932b7e998b643f9ddbf675e964c959b7b32c94b585841461305ee7a4e364f560' 
  AND token = 'MXrGGpPeEF4wRmoXNRNo6lQOWN2ZxonJzPLAzX/qODc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00026

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}