SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '3e24ead0c8b6a47f70e0f3ad24cf72f29cb7f85e8500bd010c9a62d5a03bfe76' 
  AND token = '1D/OftIiNNB15BDq2UxhSaVEFeWs+korSfpG3B6vXGQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00039

JSON explain

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