SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '3e70e3225d66bd57260e474723132173aa0e4d2e559de0ef41015a0cc2fd6dad' 
  AND token = 'epkKOv5njTwAe5lCO8cpgGPoZo063HyfEEDe/402tE0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00022

JSON explain

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