SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'c445d9602a410f2f04c31b2c7c9bfaa2c09a79ea428cefe6a4175c0de9d892ed' 
  AND token = 'M1bdw8E/iyKmjZ7QMn+D1syVy6roI7OwihEGcCurJ5g=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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