SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '02cf6f4d24121071afd90154ca8edfce4e679ffc6915d48bb7f5eb700b3d07fd' 
  AND token = 'd/i7LL436mAxm6W3aMers5RD36c6tmqK+pBvA3cADyM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00016

JSON explain

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