SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'af7c0ec7b6e8a279581e3438607daad45ec5c9b915e9b89b471002a7f6d67e7d' 
  AND token = 'JWt8n+qBi3lLCAimz0lwj/NSIss3Z3ROvmEvqH8LaOQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00037

JSON explain

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