SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '86d28aff80c6a0ddd1b92c0df1c1e9993c91ac3b2ea4532c4f2e011ca6c8dcb1' 
  AND token = 'WCQfZsUI+ZzbSBrg66nOZ8K6kxvcP05ugDfnAfmfgLE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00028

JSON explain

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