SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '43a8e3e58a941a980b1e917030c9b270183e1dc3b0709299b6247b77f92ba271' 
  AND token = 'A4h4eeSrYZ3P1ooQyEIJyZbdc8BLW0f4snO/q5+xG+M=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00025

JSON explain

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