SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1c5c8e5cd018e9fb5a2482f325f3b8adbb598e35cda5621ab3bcefd20b06584d' 
  AND token = '99r8EPbc5Y4FKgjx62XtLJj3sEUlJJ32tz8lgM2jPVs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00591

JSON explain

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