SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'cc8671ffb90a122c35d6dcf829924176b97e8fa190f88506b9f05a4d9f1ef666' 
  AND token = 'exZwRxJlc1aNDLP8hBb+Xmyf1Jx5HBEWczR37qnRqPY=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00025

JSON explain

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