SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '19d10f713a135ed0a9db868474a401d78816739b662d87d21def264bf45a336b' 
  AND token = 'CKmFtt+SjfAqG7HAclp1cA6dvlDyiEWSxe4ARBZ4XGU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00037

JSON explain

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